CREATE TABLE cities ( city_id serial PRIMARY KEY, city_name VARCHAR (255) NOT NULL, population INT NOT NULL CHECK (population >= 0) );
CREATE TABLE films_recent AS SELECT * FROM films WHERE date_prod >= '2002-01-01';